﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Sharp.Migrations;

namespace Budgeter.Migrations
{
    class _003_Create_Table_EntryType : SchemaMigration
    {

        public override void Up()
        {
            Add.Table("EntryType").WithColumns(
                Column.AutoIncrement("EntryTypeId").AsPrimaryKey(),
                Column.String("Name").NotNull(),
                Column.String("Category").NotNull(),
                Column.Boolean("IsIncome").NotNull()
            );
        }

        public override void Down()
        {
            Remove.Table("EntryType");
        }
    }
}
